﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using ebay.Utility;
using System.Drawing;

namespace ebay.Utility
{
    public class k3Class
    {
        public static DataSet GetICInventory(string FItemID)
        {
            string cmdText1 = "select FStockID,FQty from ICInventory where FItemID =" + FItemID;
            DataSet ds = new DataSet();
            using (SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CenterDBConnectionString"].ConnectionString))
            {
                connection.Open();
                SqlDataAdapter adapter = new SqlDataAdapter(cmdText1,connection);
                adapter.Fill(ds);

                return ds;
            }
        }
    }
}
